﻿CREATE VIEW [acms].[UserPostComment_View]
AS 
	SELECT 
		a.[Id],
		a.[UserId],
		b.[UserName],
		a.[PostId],
		a.[Title],
		a.[Comment],
		a.[IPAddress],
		a.[Reviewed],
		a.[Reported],
		a.[Suspended],
		a.[Created],
		a.[ConcurencyId]
	FROM [UserPostComment] a
		inner join User_View b on a.UserId = b.Id
	WHERE [Deleted] = 0
;